﻿<%@ Page Title="Flight Passengers" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="DepFltPax.aspx.cs" Inherits="IFD2.DepFltPax" %>

<%@ Register Src="~/ctlSeatMatching.ascx" TagPrefix="uc1" TagName="ctlSeatMatching" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <form id="form1" runat="server" role="form" class="form-inline" defaultbutton="lbtnQuery">
    <div class="container-fluid body-content" style="width:100%;">

    <div class="row">
        <div class="col-sm-2 well well-sm">
            <h5><asp:Literal ID="litTitle" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h5>
            <div class="form-group">
                <asp:Label ID="Label3" runat="server" Text="Airline:" meta:resourcekey="Airline"></asp:Label><br />
                <asp:DropDownList ID="lstAirlines" runat="server" DataSourceID="sqlConsignAirlines" DataTextField="airline" 
                    DataValueField="airline" CssClass="form-control input-sm" Width="100%">
                </asp:DropDownList>
            </div>
            <div class="form-group">
                <asp:Label ID="Label1" runat="server" Text="Flight:" meta:resourcekey="Flight"></asp:Label>
                <asp:TextBox ID="txtFltNo" runat="server" CssClass="form-control input-sm" Width="100%" MaxLength="8"></asp:TextBox>
            </div>
            <div class="form-group">
                <asp:Label ID="Label2" runat="server" Text="Date:" meta:resourcekey="Date"></asp:Label>
                <asp:TextBox ID="txtFltDate" runat="server" CssClass="form-control input-sm" Width="100%" MaxLength="15"></asp:TextBox>
            </div>
            <div class="form-group">
                <asp:Label ID="Label7" runat="server" Text="Airport:" meta:resourcekey="Airport"></asp:Label>
                <asp:Label ID="lblDcsAirport" runat="server"></asp:Label>
            </div>
            <br class="hidden-xs"/>
            <div class="form-group">
                <asp:CheckBox ID="chkIsGroup" runat="server" meta:resourcekey="GroupOrders" Text="Group" />
            </div>
            <div class="form-group">
                <asp:Label ID="Label5" runat="server" Text="Status:" meta:resourcekey="Status"></asp:Label>
                <asp:DropDownList ID="lstStatus" runat="server" CssClass="form-control input-sm" Width="100%">
                    <asp:ListItem Value="N" Selected="True" meta:resourcekey="NoShow" Text="No-show"></asp:ListItem>
                    <asp:ListItem Value="O" meta:resourcekey="Out" Text="Checked-out"></asp:ListItem>
                    <asp:ListItem Value="C" meta:resourcekey="Checked" Text="Checked-in"></asp:ListItem>
                    <asp:ListItem Value="K" meta:resourcekey="Keap" Text="Keap"></asp:ListItem>
                    <asp:ListItem Value="B" meta:resourcekey="Boarded" Text="Boarded"></asp:ListItem>
                    <asp:ListItem Value="F" meta:resourcekey="Flown" Text="Flown"></asp:ListItem>
                </asp:DropDownList>
            </div>
            <br class="hidden-xs"/><br class="hidden-xs"/>
            <asp:LinkButton ID="lbtnQuery" runat="server" CssClass="form-control input-sm btn-primary text-center" Width="100%" ToolTip="" meta:resourcekey="tipQuery" OnClick="lbtnQuery_Click"> <span class="glyphicon glyphicon-search" style="font-size:large;"></span></asp:LinkButton>
            <p></p><%--没有此行(或&nbsp;)，上面的按钮在手机模式(xs)下，只有上半部可以点击！--%>

            <asp:SqlDataSource ID="sqlConsignAirlines" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" SelectCommand="bll_office_get_consign_airline_codes" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                <SelectParameters>
                    <asp:SessionParameter Name="office" SessionField="OFFICE" Type="String" />
                    <asp:SessionParameter Name="airport" SessionField="DCS_AIRPORT" Type="String" />
                    <asp:SessionParameter DefaultValue="" Name="user_airline" SessionField="AIRLINE" Type="String" />
                </SelectParameters>
            </asp:SqlDataSource>
        </div>

        <div class="col-sm-10 well well-sm">
            <div class="panel">
                <div class="panel-heading btn-primary">
                    <h6 class="panel-title" id="section-2"><asp:Literal ID="Literal1" runat="server" meta:resourcekey="tipPageTitle"></asp:Literal></h6>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" style="min-width:2800px;width:100%;" class="table-hover"
                            DataKeyNames="bk_id,pax_sn,trip_sn" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None">
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <Columns>
                                <asp:TemplateField>
                                    <ItemTemplate>
                                    <input type="radio" name="KEY" value='<%#Eval("bk_id")+"|"+Eval("pax_sn")+"|"+Eval("trip_sn") %>' />
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Transfer"  meta:resourcekey="Transfer1">
                                    <ItemTemplate>
                                    <asp:CheckBox ID="select"  runat="server" />
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="flight"  meta:resourcekey="flight1">
                                    <ItemTemplate>
                                        <%#Eval("airline") + "" + Eval("flt_no")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:CheckBoxField DataField="virtual" HeaderText="virtual" SortExpression="virtual" meta:resourcekey="virtual"/>
                                <asp:TemplateField HeaderText="op_flight"  meta:resourcekey="op_flight">
                                    <ItemTemplate>
                                        <%#Eval("op_airline") + "" + Eval("op_flt_no")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="ori_airport" HeaderText="ori_airport" SortExpression="ori_airport"  meta:resourcekey="ori_airport" />
                                <asp:BoundField DataField="des_airport" HeaderText="des_airport" SortExpression="des_airport"  meta:resourcekey="des_airport" />
                                <asp:BoundField DataField="seat_type" HeaderText="seat_type" SortExpression="seat_type"  meta:resourcekey="reserve_type" />
                                <asp:CheckBoxField DataField="vip" HeaderText="VIP" SortExpression="vip" />
                                <asp:CheckBoxField DataField="alone_chd" HeaderText="alone_chd" SortExpression="alone_chd"  meta:resourcekey="alone_chd" />
                                <asp:BoundField DataField="move_assistant" HeaderText="move_assistant" SortExpression="move_assistant"  meta:resourcekey="move_assistant" />
                                <asp:BoundField DataField="meal" HeaderText="meal" SortExpression="meal"  meta:resourcekey="meal" />
                                <asp:TemplateField HeaderText="Name"  meta:resourcekey="Name1">
                                    <ItemTemplate>
                                        <%#Eval("family_name") + "/" + Eval("name")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="tkt_no" SortExpression="tkt_no" meta:resourcekey="tkt_no">
                                    <ItemTemplate>
                                        <a href='Ticket.aspx?tkt_no=<%# Convert.ToInt64(Eval("bk_id")) * 1000 + Convert.ToInt16(Eval("pax_sn")) %>'><%# Convert.ToInt64(Eval("bk_id")) * 1000 + Convert.ToInt16(Eval("pax_sn"))%></a>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="trip_sn" HeaderText="trip_sn" ReadOnly="True" SortExpression="trip_sn"  meta:resourcekey="trip_sn" />
                                <asp:CheckBoxField DataField="hold_inf" HeaderText="hold_inf" SortExpression="hold_inf"  meta:resourcekey="hold_inf"  Visible="false"/>
                                <asp:BoundField DataField="cabin" HeaderText="cabin" SortExpression="cabin"  meta:resourcekey="cabin1" />
                                <asp:BoundField DataField="class" HeaderText="class" SortExpression="class"  meta:resourcekey="class1" />
                                <asp:BoundField DataField="seat_status" HeaderText="seat_status" SortExpression="seat_status"  meta:resourcekey="seat_status" />
                                <asp:BoundField DataField="age_type" HeaderText="age_type" SortExpression="age_type"  meta:resourcekey="age_type" />
                                <asp:BoundField DataField="dcs_status" HeaderText="dcs_status" SortExpression="dcs_status"  meta:resourcekey="dcs_status" />
                                <asp:TemplateField HeaderText="Seat"  meta:resourcekey="Seat1">
                                    <ItemTemplate>
                                        <%#Eval("seat_row") + "" + Eval("seat_col")%>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="dcs_user" HeaderText="dcs_user" SortExpression="dcs_user"  meta:resourcekey="dcs_user" />
                                <asp:BoundField DataField="dcs_time" HeaderText="dcs_time" SortExpression="dcs_time"  meta:resourcekey="dcs_time" />
                        
                                <asp:BoundField DataField="nationality" HeaderText="nationality" SortExpression="nationality"  meta:resourcekey="nationality1" />
                                <asp:BoundField DataField="id_type" HeaderText="id_type" SortExpression="id_type"  meta:resourcekey="id_type" />
                                <asp:BoundField DataField="id_no" HeaderText="id_no" SortExpression="id_no"  meta:resourcekey="id_no" />
                                <asp:BoundField DataField="id_expired_date" HeaderText="id_expired_date" SortExpression="id_expired_date"  meta:resourcekey="id_expired_date" DataFormatString="{0:d}" />
                                <asp:BoundField DataField="inf_dob" HeaderText="inf_dob" SortExpression="inf_dob"  meta:resourcekey="inf_dob" DataFormatString="{0:d}" />
                                <asp:BoundField DataField="ffp_airline" HeaderText="ffp_airline" SortExpression="ffp_airline"  meta:resourcekey="ffp_airline" />
                                <asp:BoundField DataField="ffp_no" HeaderText="ffp_no" SortExpression="ffp_no"  meta:resourcekey="ffp_no" />
                                <asp:BoundField DataField="pax_value" HeaderText="pax_value" SortExpression="pax_value"  meta:resourcekey="pax_value" />
                                <asp:BoundField DataField="remark" HeaderText="remark" SortExpression="remark"  meta:resourcekey="remark" />
                                <asp:BoundField DataField="email" HeaderText="email" SortExpression="email"  meta:resourcekey="email1" />
                                <asp:BoundField DataField="mobile_phone" HeaderText="mobile_phone" SortExpression="mobile_phone"  meta:resourcekey="mobile_phone" />
                                <asp:CheckBoxField DataField="is_group" HeaderText="is_group" SortExpression="is_group"  meta:resourcekey="is_group" />
                            </Columns>
                            <RowStyle BackColor="#EFF3FB" />
                            <EditRowStyle BackColor="#2461BF" />
                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <AlternatingRowStyle BackColor="White" />
                        </asp:GridView>

                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                            SelectCommand="bll_flt_get_pax_list_by_airport" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="lstAirlines" Name="airline" PropertyName="SelectedValue" Type="String" />
                                <asp:ControlParameter ControlID="txtFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                                <asp:ControlParameter ControlID="txtFltDate" Name="flt_date" PropertyName="Text" Type="DateTime" />
                                <asp:SessionParameter Name="airport" SessionField="DCS_AIRPORT" Type="String" />
                                <asp:ControlParameter ControlID="chkIsGroup" Name="is_group" PropertyName="Checked" Type="Boolean" />
                                <asp:ControlParameter ControlID="lstStatus" Name="status" PropertyName="SelectedValue" Type="String" />
                                <asp:SessionParameter Name="office" SessionField="OFFICE" Type="String" />
                                <asp:SessionParameter DefaultValue="" Name="user_airline" SessionField="AIRLINE" Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    </div>
                    <asp:Label ID="Label4" runat="server" Text="Total:" meta:resourcekey="Total"></asp:Label>
                    <asp:Label ID="lblRowCount" runat="server" Font-Bold="True"></asp:Label><br />
                    <asp:Label ID="Label22" runat="server" meta:resourcekey="AssistantNote" Text="AssistantNote" Font-Italic="true"></asp:Label><br />
                    <asp:Label ID="Label33" runat="server" meta:resourcekey="MealNote" Text="MealNote" Font-Italic="true"></asp:Label>

                    <div class="well well-sm">
                        <div class="form-group">
                        <asp:Label ID="Label6" runat="server" Text="New Status:" meta:resourcekey="NewStatus"></asp:Label>&nbsp;
                        <asp:DropDownList ID="lstStatus2" runat="server">
                            <asp:ListItem Value="N" meta:resourcekey="NoShow" Text="No-show"></asp:ListItem>
                            <asp:ListItem Value="C" meta:resourcekey="Checked">Ret2Checked</asp:ListItem>
                            <asp:ListItem Value="O" meta:resourcekey="Out" Text="Checked-out"></asp:ListItem>
                            <asp:ListItem Value="K" meta:resourcekey="Keap" Text="Keap"></asp:ListItem>
                            <asp:ListItem Value="B" meta:resourcekey="Boarded" Text="Boarded"></asp:ListItem>
                            <asp:ListItem Value="T" Enabled="false">Transfered!</asp:ListItem>
                            <asp:ListItem Value="U" Enabled="False">Unboard?</asp:ListItem>
                            <asp:ListItem Value="D" meta:resourcekey="Draw" Text="Draw Away?" Enabled="False"></asp:ListItem>
                        </asp:DropDownList>
                        </div>
                        <!--asp:ListItem Value="C" Selected="True" meta:resourcekey="Checked"  Text="Super Check-in"></asp:ListItem-->
                        <asp:Button ID="btnSetStatus" runat="server" Text="Set Status" OnClick="btnSetStatus_Click"  meta:resourcekey="SetStatus" CssClass="btn btn-sm btn-default" />
                        <div class="form-group">
                        <asp:Label ID="Label15" runat="server" Text="Note: Re-Keap will reset to Checked-in." meta:resourcekey="ReKeapNote" Font-Italic="true"></asp:Label>
                        </div>
                        <br />
                        <asp:Label ID="lblError" runat="server" CssClass="ifdMessage"></asp:Label>
                    </div>

                    <div class="well well-sm">
                        <asp:Label ID="Label8" runat="server" Font-Bold="True" Text="Seat Matching" meta:resourcekey="SeatMatching"></asp:Label>
                        <div class="table-responsive">
                            <uc1:ctlSeatMatching runat="server" id="ctlSeatMatching" />
                        </div>
                        <br />
                        <asp:Label ID="Label35" runat="server" meta:resourcekey="ReservedType" Text="Set Seat Type: " Font-Bold="True"></asp:Label>
                        <asp:TextBox ID="txtNewValue" runat="server" MaxLength="2" Width="21px">*</asp:TextBox>
                        <asp:Label ID="Label36" runat="server" meta:resourcekey="legNoControl" Text="[* = No Control]" Font-Italic="true"></asp:Label>
                        <br />
                        <asp:Label ID="Label37" runat="server" Text="Where:" meta:resourcekey="Where"></asp:Label>
                        <br />
                        <asp:TextBox ID="txtWhere" runat="server" Height="69px" MaxLength="100" 
                            TextMode="MultiLine" Width="100%">bk_id=9999999 and pax_sn=9 and (class=&#39;Y&#39;  or cabin=&#39;F&#39;) 
and fare_code=&#39;XXX&#39; and des_airport=&#39;XXX&#39; and vip=1 and seat_type like &#39;%X%</asp:TextBox>
                        <br />
                        <asp:Label ID="Label18" runat="server"  Font-Italic="true" meta:resourcekey="AvailFields" Text="Avail key words: bk_id,pax_sn,trip_sn,seat_type,class,cabin,fare_code,age_type,ori_airport,des_airport,vip,alone_chd,seat_status"></asp:Label>
                        <br />
                        <asp:Button ID="btnChange" runat="server" CssClass="btn btn-sm btn-default" meta:resourcekey="Change" onclick="btnChange_Click" Text="Set" />
                        <br />
                        <asp:Label ID="lblErrChange" runat="server" CssClass="ifdMessage"></asp:Label>
                        <asp:Label ID="Label9" runat="server" meta:resourcekey="SeatType" Text="Seat Type:" Visible="False"></asp:Label>
                        <asp:TextBox ID="txtSeatType" runat="server" Visible="False" Width="18px" MaxLength="2">*</asp:TextBox>
                        <asp:Button ID="btnSetSeatType" runat="server" CssClass="btn btn-sm btn-default" meta:resourcekey="SetSeatType" OnClick="btnSetSeatType_Click" Text="Set Seat Type_X" Visible="False" />
                    </div>

                    <asp:Panel ID="panTransfer" runat="server">
                    <div class="well well-sm">
                        <asp:Label ID="Label10" runat="server" Font-Bold="True" Text="Transfer To: " meta:resourcekey="TransferTo"></asp:Label><br />
                        <div class="form-group">
                        <asp:Label ID="Label16" runat="server" Text="Airline:" meta:resourcekey="Airline"></asp:Label>
                        <asp:DropDownList ID="lstXferAirline" runat="server" DataSourceID="sqlAirlines" DataTextField="code" DataValueField="code" ondatabound="lstXferAirline_DataBound"></asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label11" runat="server" Text="Fltight No.:" meta:resourcekey="Flight"></asp:Label>
                        <asp:TextBox ID="txtFltNoXfer" runat="server" Width="80px" MaxLength="6"></asp:TextBox>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label12" runat="server" Text="Date:" meta:resourcekey="Date"></asp:Label>
                        <asp:TextBox ID="txtFltDateXfer" runat="server" Width="83px" MaxLength="12"></asp:TextBox>
                        </div>
                        <asp:Button ID="btnRetreive2" runat="server" CssClass="btn btn-sm btn-default" OnClick="btnRetreive2_Click" Text="Retreive" meta:resourcekey="Retreive"/>
                        <br /><br />
                        <div class="form-group">
                        <asp:Label ID="Label13" runat="server" meta:resourcekey="Segment" Text="Segment:"></asp:Label>
                        <asp:DropDownList ID="lstOri" runat="server" AutoPostBack="True" DataSourceID="sqlXOrigins" DataTextField="ori_airport" DataValueField="ori_airport" OnSelectedIndexChanged="lstOri_SelectedIndexChanged"></asp:DropDownList>
                        -
                        <asp:DropDownList ID="lstDes" runat="server" AutoPostBack="True" DataSourceID="sqlXDestinations" DataTextField="des_airport" DataValueField="des_airport" OnSelectedIndexChanged="lstDes_SelectedIndexChanged"></asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label14" runat="server" meta:resourcekey="Cabin" Text="Cabin:"></asp:Label>&nbsp;
                        <asp:DropDownList ID="lstCabins" runat="server" AutoPostBack="True" DataSourceID="sqlXCabins" DataTextField="cabin" DataValueField="cabin"  OnSelectedIndexChanged="lstCabins_SelectedIndexChanged"></asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label17" runat="server" meta:resourcekey="Class" Text="Class:"></asp:Label>&nbsp;
                        <asp:DropDownList ID="lstClasses" runat="server" DataSourceID="sqlXClasses" DataTextField="class" DataValueField="class"></asp:DropDownList>
                        </div>
                        <asp:Button ID="btnTransfer" runat="server" CssClass="btn btn-sm btn-default" OnClick="btnTransfer_Click" Text="Batch Transfer" meta:resourcekey="Transfer" />
                        <div class="form-group">
                        <asp:Label ID="Label19" runat="server" Text="Note: Target class should be in 'Transfer-in' status." meta:resourcekey="XferNote" Font-Italic="true"></asp:Label>
                        </div>
                        <br class="hidden-xs" />
                        <asp:Label ID="lblErrTransfer" runat="server" CssClass="ifdMessage"></asp:Label>
                    </div>
                    </asp:Panel>

                    <asp:Panel ID="panGoshow" runat="server">
                    <div class="well well-sm">
                        <asp:Label ID="Label20" runat="server" Font-Bold="True" Text="Go-show"></asp:Label><br />
                        <div class="form-group">
                        <asp:Label ID="Label263" runat="server" Text="Ori. Airport:" meta:resourcekey="OriAirport"></asp:Label>
                        <asp:TextBox ID="txtOriAirport" runat="server" MaxLength="4" ReadOnly="True" Width="35px"></asp:TextBox>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label264" runat="server" Text="Des. Airport:" meta:resourcekey="DesAirport"></asp:Label>
                        <asp:DropDownList ID="lstDesAirport" runat="server" 
                            DataSourceID="sqlDesAirports" DataTextField="des_airport" 
                            DataValueField="des_airport">
                        </asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label21" runat="server" meta:resourcekey="Cabin" Text="Cabin:"></asp:Label>
                        <asp:DropDownList ID="lstCabin" runat="server" AutoPostBack="True" 
                            DataSourceID="sqlCabin" DataTextField="cabin" DataValueField="cabin">
                        </asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label23" runat="server" Text="Class:" meta:resourcekey="Class"></asp:Label>
                        <asp:DropDownList ID="lstClass" runat="server" DataSourceID="sqlClass" 
                            DataTextField="class" DataValueField="class">
                        </asp:DropDownList>
                        </div>
                        <br class="hidden-xs" />
                        <div class="form-group">
                        <asp:Label ID="Label25" runat="server" Text="Family Name:" meta:resourcekey="FamilyName"></asp:Label>
                        <asp:TextBox ID="txtFamilyName" runat="server" MaxLength="16"></asp:TextBox>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label262" runat="server" Text="Name:" meta:resourcekey="Name"></asp:Label>
                        <asp:TextBox ID="txtName" runat="server" MaxLength="20"></asp:TextBox>
                        </div>
                        <br class="hidden-xs"/>
                        <div class="form-group">
                        <asp:Label ID="Label27" runat="server" Text="Family Name(EN):" meta:resourcekey="FamilyNameEN"></asp:Label>
                        <asp:TextBox ID="txtFamilyNameEn" runat="server" MaxLength="20"></asp:TextBox>
                        </div>
                        <asp:Label ID="Label28" runat="server" Text="Name(EN):" meta:resourcekey="NameEN"></asp:Label>
                        <asp:TextBox ID="txtNameEn" runat="server" MaxLength="20"></asp:TextBox>
                        <br class="hidden-xs" />
                        <div class="form-group">
                        <asp:Label ID="Label24" runat="server" meta:resourcekey="AgeType" Text="Age Type:"></asp:Label>
                        <asp:DropDownList ID="lstAgeType" runat="server" AutoPostBack="True" onselectedindexchanged="lstAgeType_SelectedIndexChanged">
                            <asp:ListItem meta:resourcekey="Adult" Selected="True" Value="A">Adult</asp:ListItem>
                            <asp:ListItem meta:resourcekey="Child" Value="C">Child</asp:ListItem>
                            <asp:ListItem meta:resourcekey="Infant" Value="I">Infant</asp:ListItem>
                        </asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label26" runat="server" meta:resourcekey="Gender" Text="Gender:"></asp:Label>&nbsp;
                        <asp:RadioButton ID="radMale" runat="server" GroupName="gender" meta:resourcekey="Male" Text="Male" />
                        <asp:RadioButton ID="radFemale" runat="server" GroupName="gender" meta:resourcekey="Female" Text="Female" />
                        </div>
                        <div class="form-group">
                        <asp:Label ID="lblInfDOB" runat="server" meta:resourcekey="InfantDOB" Text="Infant DOB:"></asp:Label>
                        <asp:TextBox ID="txtInfantDob" runat="server" Width="96px" MaxLength="12"></asp:TextBox><br />
                        </div>
                        <br class="hidden-xs" />
                        <div class="form-group">
                        <asp:Label ID="Label29" runat="server" meta:resourcekey="Nationality" Text="Nationality:"></asp:Label>
                        <asp:DropDownList ID="lstNations" runat="server" DataSourceID="sqlNations" DataTextField="name" DataValueField="code">
                        </asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label30" runat="server" Text="ID Type:" meta:resourcekey="IDType"></asp:Label>
                        <asp:DropDownList ID="lstIdTypes" runat="server">
                            <asp:ListItem meta:resourcekey="ID" Selected="True" Value="I">ID</asp:ListItem>
                            <asp:ListItem meta:resourcekey="Passport" Value="P">Passport</asp:ListItem>
                            <asp:ListItem meta:resourcekey="Military" Value="M">Military</asp:ListItem>
                        </asp:DropDownList>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label31" runat="server" Text="ID No.:" meta:resourcekey="IDNo"></asp:Label>
                        <asp:TextBox ID="txtIdNo" runat="server" MaxLength="20"></asp:TextBox>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label32" runat="server" meta:resourcekey="Expriy" Text="Expriy:"></asp:Label>
                        <asp:TextBox ID="txtExpiry" runat="server" Width="97px" MaxLength="12"></asp:TextBox>
                        </div>
                        <br class="hidden-xs" />
                        <div class="form-group">
                        <asp:Label ID="Label34" runat="server" meta:resourcekey="Phone" Text="Mobile Phone:"></asp:Label>
                        <asp:TextBox ID="txtPhone" runat="server" Width="109px" MaxLength="16"></asp:TextBox>
                        </div>
                        <div class="form-group">
                        <asp:Label ID="Label38" runat="server" meta:resourcekey="Email" Text="E-mail:"></asp:Label>
                        <asp:TextBox ID="txtEmail" runat="server" MaxLength="20"></asp:TextBox>
                        </div>
                        <br class="hidden-xs" />
                        <asp:Button ID="btnGoShowPax" runat="server" CssClass="btn btn-sm btn-default" Text="Add Go-show Pax." meta:resourcekey="AddGoShow" OnClick="btnGoShowPax_Click"/><br />
                        <asp:Label ID="lblError2" runat="server" CssClass="ifdMessage"></asp:Label>
                    </div>
                    </asp:Panel>

                </div>
                <asp:SqlDataSource ID="sqlNations" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:IFD_DB %>" DataSourceMode="DataReader" 
                    SelectCommand="bll_country_get_names_by_lang" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:SessionParameter Name="lang" SessionField="LANG" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlAirlines" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                    SelectCommand="bll_airline_get_codes" SelectCommandType="StoredProcedure"  
                    DataSourceMode="DataReader"></asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlXClasses" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                    SelectCommand="bll_flt_get_transfer_class_codes" 
                    SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstXferAirline" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNoXfer" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDateXfer" Name="flt_date" PropertyName="Text" Type="DateTime" />
                        <asp:ControlParameter ControlID="lstOri" Name="ori_airport" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="lstDes" Name="des_airport" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="lstCabins" Name="cabin" PropertyName="SelectedValue" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlXCabins" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                    SelectCommand="bll_flt_get_cabin_codes" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstXferAirline" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNoXfer" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDateXfer" Name="flt_date" PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlXDestinations" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                    SelectCommand="bll_flt_get_des_airports" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstXferAirline" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNoXfer" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDateXfer" Name="flt_date" PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlXOrigins" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>"
                    SelectCommand="bll_flt_get_ori_airports" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstXferAirline" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNoXfer" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDateXfer" Name="flt_date" PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlClass" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" 
                    SelectCommand="bll_flt_get_class_codes" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstAirlines" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDate" Name="flt_date" PropertyName="Text" Type="DateTime" />
                        <asp:ControlParameter ControlID="lstCabin" Name="cabin" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtOriAirport" Name="ori_airport" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="lstDesAirport" Name="des_airport" PropertyName="SelectedValue" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlDesAirports" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" 
                    SelectCommand="bll_flt_get_des_airports" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstAirlines" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDate" Name="flt_date" PropertyName="Text" Type="DateTime" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="sqlCabin" runat="server" ConnectionString="<%$ ConnectionStrings:IFD_DB %>" 
                    SelectCommand="bll_flt_get_cabin_codes" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="lstAirlines" Name="airline" PropertyName="SelectedValue" Type="String" />
                        <asp:ControlParameter ControlID="txtFltNo" Name="flt_no" PropertyName="Text" Type="String" />
                        <asp:ControlParameter ControlID="txtFltDate" Name="flt_date" PropertyName="Text" Type="DateTime" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:HiddenField ID="hidFltDateXfer_X" runat="server" />
                <asp:HiddenField ID="hidFltNoXfer_X" runat="server" />
            </div>
        </div>
    </div>

    </div>
    </form>

    <script src="JS/ScrollableGridPlugin.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            var win_height = parseInt($(window).height());
            var tab_new_height= win_height-50-100;//菜单占50， 为便于操作留空100
            if ($('#<%=GridView1.ClientID %>').height()>tab_new_height)
                $('#<%=GridView1.ClientID %>').Scrollable({ ScrollHeight: tab_new_height });
        });
    </script>

</asp:Content>
